| NO |
欄位代號 |
鍵值 |
欄位名稱 |
型態 |
長度 |
NULL |
預設值 |
說明 |
| 1 |
oastn001 |
 |
表單代號
|
nvarchar |
30 |
|
|
|
| 2 |
oastn002 |
|
表單單號
|
nvarchar |
40 |
|
|
|
| 3 |
oastn003 |
|
序號 |
nvarchar |
4 |
|
|
|
| 4 |
oastn004 |
|
日期 |
nvarchar |
20 |
|
|
|
| 5 |
oastn005 |
|
起始地點 |
nvarchar |
20 |
|
|
|
| 6 |
oastn006 |
|
到達地點 |
nvarchar |
20 |
|
|
|
| 7 |
oastn007 |
|
車程別 |
nvarchar |
1 |
Yes |
|
0.單程 1.來回 |
| 8 |
oastn008 |
|
專案代號 |
nvarchar |
20 |
Yes |
|
|
| 9 |
oastn009 |
|
交通工具 |
nvarchar |
1 |
Yes |
|
0.機車 1.汽車 |
| 10 |
oastn010 |
|
公里數 |
int |
|
|
|
|
| 11 |
oastn011 |
|
油費金額 |
float |
|
|
|
|
| 12 |
oastn012 |
|
停車費金額 |
float |
|
Yes |
|
|
| 13 |
oastn013 |
|
回數票數量 |
int |
3 |
Yes |
|
|
| 14 |
oastn014 |
|
回數票單價 |
int |
3 |
Yes |
|
|
| 15 |
oastn015 |
|
回數票金額 |
int |
6 |
Yes |
|
|
| 16 |
oastn016 |
|
客戶/用途說明 |
nvarchar |
40 |
|
|
|
|